php forum
php mysql forum
php mysql smarty
 
Page 1 of 3 1 2 3 >
Topic Options
#233027 - 01/12/03 10:42 PM [6.2] Postlist Last Post By for 6.2
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Mod Name / Version - Postlist Last Post By for 6.2 <br /> <br />Description - Shows the "Last Post By" information on the postlist page. To save queries, I chose to store the username... so the name won't be accurate if a user has changed their display name. Since this is only stored for the last post, I figured it was worth the savings in queries. <br /> <br />Pre-requisites - none <br /> <br />Author - JustDave from www.chattersonline.com original author <br />   Updated for 6.2 by JoshPet of www.joshuapettit.com <br /> <br />Credits - Allen Ayres for testing of original version <br /> <br />Files Altered - <br />   postlist.php (threads directory) <br />   postlist.tmpl (threads directory) <br />   addpost.php (threads directory) <br />   doapproveposts.php (admin directory) <br />   viewunapproved.php (admin directory) <br />   deletepost.php (threads directory) <br /> <br />Database Altered - Yes. 3 fields (B_Last_Number, B_Last_Name, and B_Last_Approved) added to w3t_Posts table. <br /> <br />New Files - none <br /> <br />Any other info - JustDave gets a bulk of the credit here, I just adapted for 6.2. <img src="/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />Last Update: January 19, 2003


Attachments
64714-lastpostby.6.2.zip (128 downloads)



Edited by JustDave (01/19/03 03:51 PM)
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233028 - 01/12/03 11:25 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
AllenAyres Offline

I type Like navaho

Registered: 03/10/00
Posts: 25580
Loc: Texas
thank you <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
- Allen wavey
- What Drives You?

Top
#233029 - 01/12/03 11:33 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: SurfMinister]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
You are welcome. Sometimes I need a nudge to get stuff onto my plate.<br /><br />JustDave my know a better way to do this. I stored the username for last post to save queries. So it won't change when the name changes, but it changes as soon as there's another post in that thread anyway, so for my board, I didn't see it as a big issue. <br /><br />The link still works... and as we have discovered here, once the name change thing gets tested out, it's doesn't happen that frequently. <br /><br />But otherwise it required another query per thread being viewed. Probably could have been done like the [Re: Username] thing with an array, but that one escapes me at my current coding level. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233030 - 01/12/03 11:38 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
AllenAyres Offline

I type Like navaho

Registered: 03/10/00
Posts: 25580
Loc: Texas
it escapes me at my next 2 coding levels <img src="/forum/images/graemlins/wink.gif" alt="" />
_________________________
- Allen wavey
- What Drives You?

Top
#233031 - 01/12/03 11:45 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: SurfMinister]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
LOL - I'm gaining on it. But I didn't sleep last night (bad new habit of skipping sleep on Saturday night <img src="/forum/images/graemlins/crazy.gif" alt="" />) so I can't even comprehend it right now. <img src="/forum/images/graemlins/tongue.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233032 - 01/13/03 06:14 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Yeah I was stopped at that point on this. I need to set that same array setup on this to get the usernames from their numbers. I'll update your instructions when I do this. Thanks for bringing it up to speed for 6.2 <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233033 - 01/14/03 03:29 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Is deletepost.php working for you? It must be late but I can't see what I may have done wrong... lol It's something simple so it's alluding me right now. I think I'm looking way to deep. LoL <img src="/forum/images/graemlins/crazy.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233034 - 01/14/03 03:39 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
It was working for me... I'll send you my deletepost and you can compare. <img src="/forum/images/graemlins/tongue.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233035 - 01/14/03 03:42 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Thanks but I think it's do to my own coding mess at the moment... LoL I'll get my stuff cleaned up.
_________________________
~Dave
ChattersOnline.com

Top
#233036 - 01/14/03 09:15 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Test <img src="/forum/images/graemlins/wink.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233037 - 01/14/03 09:23 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Ok at the cost of one query in postlist.php and saving 1 query in the other scripts I have this working with user numbers. yay <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I'll append the instructions sometime today. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233038 - 01/14/03 09:56 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Hey, <br />I just noticed both on my board and here (since installing this) that my new post rows aren't ligthing up.<br /><br />Can't think of why this would mess that up.... can you?<br /><br /><img src="/forum/images/graemlins/confused.gif" alt="" /><br /><br />Or is this just a mac thing? <img src="/forum/images/graemlins/tongue.gif" alt="" /><br /><br />It doesn't mess with classes in the postlist.tmpl file.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233039 - 01/14/03 09:57 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
hmmmm.... I hadn't noticed. I'll look things over and see what may be the cause. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233040 - 01/14/03 11:24 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Ok I finished cleaning things up a bit. There's a new create/alter table script as well so that old installs can update and use the user numbers.<br /><br />Will zip and post shortly. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233041 - 01/14/03 11:30 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
You got the post lines working again. <img src="/forum/images/graemlins/grin.gif" alt="" /><br /><br />Yeah. Well I tried and came close.... as usual. Always need JustDave around to finalize things. <img src="/forum/images/graemlins/wink.gif" alt="" /><br /><br />Thanks Dave. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233042 - 01/14/03 11:40 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
Your welcome <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I just updated the zip. There's a new createlastpostfields-6.2.php script everyone will need to run. For those that are upgrading this will clean out the B_Last_Name field and change it's type to INT(9).<br /><br />You'll need to be logged in as an admin and the forums need to be closed to access the script.
_________________________
~Dave
ChattersOnline.com

Top
#233043 - 01/17/03 05:34 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
Ian_W Offline

Veteran

Registered: 02/22/02
Posts: 2575
Loc: England
Thanks for this Josh & Dave - will be installing today <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />
_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)

Top
#233044 - 01/18/03 05:21 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Gorlum]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Dave - <br />I thought I could fix this on my own...but the way you've thrown all the user numbers into an array... it confuses me. <img src="/forum/images/graemlins/crazy.gif" alt="" /><br /><br />Anyway... need to add a clause if the user number is 1, then it needs to fetch the anon name from he post table. Otherwise the last posts (if anon) show up as ***DONOTDELETE*** <img src="/forum/images/graemlins/tongue.gif" alt="" /><br /><br />Ugh.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233045 - 01/18/03 07:03 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
Astaran Offline
Addict

Registered: 12/21/00
Posts: 1545
Loc: Germany
JustDave, i installed this one also and it works very well.<br />But i have a question regarding the field B_Last_Approved.<br />What's the different to B_Approved?<br />I think it stores exactly the same values or did i get something wrong?
_________________________
Running a community? -> Keep informed and take it to the next level

Top
#233046 - 01/18/03 07:34 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: -Fusion-]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
The B_Last_Approved is 'yes' by default just as is B_Approved. If a user replies to a thread and their reply needs approval then it will not be displayed in the "Last Post By" information untill it is approved. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233047 - 01/18/03 07:35 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
I'll work on this one too today. There should be no additional queries needed. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233048 - 01/19/03 03:55 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
I have updated the zip to include a code change for postlist.php which will display "Anonymous" for posts stored under user number 1. To properly display anonymous names when allowed there will be an additional field required to store this information in. I'll work on updating this to allow for it sometime soon. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233049 - 01/20/03 04:18 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: sjsaunders]
Astaran Offline
Addict

Registered: 12/21/00
Posts: 1545
Loc: Germany
[]The B_Last_Approved is 'yes' by default just as is B_Approved. [/] <br />So can't you use the B_Approved field to check if the posting is approved and only update "Last Post By" if it is?<br />Just guessing, if this field is really necessary.
_________________________
Running a community? -> Keep informed and take it to the next level

Top
#233050 - 01/20/03 04:22 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: -Fusion-]
JustDave Offline
That 70's Guy

Registered: 06/24/01
Posts: 4097
If the post isn't approved then B_Last_Approved will be set to 'no' and will not be used to update the last post info. (or it didn't used to, did that change?)<br /><br />Once the post is approved it will be appended to the last post info. (or it should be)<br /><br />I'll have to go over everything sometime soon to add in the ability to track anonymous post names if used/allowed. If somehow this field has not gotten used for the way I had intended I'll get it fixed. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
~Dave
ChattersOnline.com

Top
#233051 - 02/13/03 12:52 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Moved to finished mods forum.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233052 - 03/06/03 02:49 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
Rick Offline
Guru

Registered: 05/11/99
Posts: 8373
Loc: Olympia, WA
A modification of this will be part of 6.3. Added 1 extra query to the postlist.php script so usernames will be right if a user changes their username.
_________________________
UBB.threads Developer

Top
#233053 - 03/06/03 02:53 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Sally]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Yeah!! <img src="/forum/images/graemlins/smile.gif" alt="" /><br /> <img src="/forum/images/graemlins/waytogo.gif" alt="" /> <img src="/forum/images/graemlins/peace.gif" alt="" /> <img src="/forum/images/graemlins/bow.gif" alt="" /> <img src="/forum/images/graemlins/rainbow.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233054 - 03/11/03 05:33 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
ckvsoft Offline
Lurker

Registered: 11/14/01
Posts: 8
Loc: Vienna, Austria
Hi<br />Anyone knows why this hack is not a standard to ubbthread?<br /><br />mfg Chris
_________________________
bye chris
k3b.org
ckvsoft.at

Top
#233055 - 03/11/03 05:44 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: 3109A469]
Dalantech Offline
Junior Member

Registered: 02/11/01
Posts: 2392
Loc: Naples, Italy
[]ckvsoft said:<br />Hi<br />Anyone knows why this hack is not a standard to ubbthread?<br /><br />mfg Chris [/]<br /><br />If you look a few posts up from this one the programmer who wrote UBB Threads (Scream) said it will be in the next release... <img src="/forum/images/graemlins/wink.gif" alt="" />
_________________________
Da LAN Tech

Threads Dev Moderator

Top
#233056 - 03/12/03 04:54 AM Re: [6.2] Postlist Last Post By for 6.2 [Re: jacksonm99]
ckvsoft Offline
Lurker

Registered: 11/14/01
Posts: 8
Loc: Vienna, Austria
Thanx
_________________________
bye chris
k3b.org
ckvsoft.at

Top
#233057 - 06/19/03 07:36 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: 3109A469]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
I am wondering if this is conflicting with another mod, I have tried this over and over and can't get it to work and it looks like everyone else is fine so I am not sure what's going on. After my first failure I dropped the tables and started over from scratch (and re-ran the table install script provided in the download) and enabled error logging, here is what I got after my last attempt <br />
Code:
Unable to do_query: INSERT INTO w3t_Boards (Bo_Title,Bo_Description,Bo_Keyword,Bo_Total,Bo_Last,Bo_HTML, <br />Bo_Created,Bo_Expire,Bo_Markup, <br />Bo_Cat,Bo_Moderated,Bo_CatName,Bo_Read_Perm,Bo_Write_Perm,Bo_ThreadAge,Bo_Reply_Perm, <br />Bo_SpecialHeader,Bo_StyleSheet,Bo_Posterid,Bo_LastNumber)
<br /> <br />This (or most of it) appeared on every page so I just put back the backed up files, any ideas? <br /> <br />edit: added line breaks


Edited by JoshPet (06/19/03 08:16 PM)

Top
#233058 - 06/19/03 07:50 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
What was the rest of the error? Was there more? It seems to stop before it says what part it doesn't like.<br /><br />Did you add the database fields to your database?
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233059 - 06/19/03 08:12 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
The rest of it was related to specific forums that I had, here is the whole thing (sorry) and I did add the database fields per createlastpostfields-6.2.php. After the first didn't take I dropped the tables and added it again, then re-modded all the pages from scratch <br /> <br />
Code:
Unable to do_query: INSERT INTO w3t_Boards (Bo_Title,Bo_Description,Bo_Keyword,Bo_Total,Bo_Last, <br />Bo_HTML,Bo_Created,Bo_Expire,Bo_Markup,Bo_Cat,Bo_Moderated,Bo_CatName,Bo_Read_Perm, <br />Bo_Write_Perm,Bo_ThreadAge,Bo_Reply_Perm,Bo_SpecialHeader,Bo_StyleSheet,Bo_Posterid,Bo_LastNumber) <br />VALUES ('Bootleg Trading', 'Want to swap boots? Come on in. Please no uploading in <br />this forum.', 'bootlegs','0','0','Off','1055220294','0','On','1','no','Music Files', <br />'-1-2-3-4-5-','-1-2-3-5-','0','-1-2-3-5-','0','usedefault','','') - <br />Duplicate entry 'bootlegs' for key 2 
<br /> <br />edit added line breaks because none of us have a 10 foot wide monitor <img src="/forum/images/graemlins/wink.gif" alt="" />


Edited by JoshPet (06/19/03 08:17 PM)

Top
#233060 - 06/19/03 08:22 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
OK -<br /><br />[]<br />Duplicate entry 'bootlegs' for key 2 <br />[/]<br />That part at the very end is what I was looking for - that's the actual error as to why it couldn't complete the query. The begining is just the query.<br /><br />This error looks like you are trying to create a second forum with the keyword of 'bootlegs' but you already have this forum.<br /><br />Each forum must have a unique keyword.<br /><br />Were you trying to add a new forum to your board?<br /><br />That wouldn't have anything to do with this mod - this mod has to do with adding posts and tracking who posted to it last. It does not alter the w3t_Boards table - it only alters the w3t_Posts table.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233061 - 06/19/03 08:42 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
Okay dude, you gotta be thinking I just got off the short bus here lol. Let's try this error and see if we can get to the problem at hand shall we? <img src="/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />
Code:
Unable to do_query: ALTER TABLE w3t_Posts ADD B_Last_Number INT(11) <br />UNSIGNED NOT NULL, ADD B_Last_Name INT(9) UNSIGNED NOT NULL, ADD <br />B_Last_Approved varchar(3) DEFAULT 'yes' NOT NULL - <br />Duplicate column name 'B_Last_Number' 
<br /> <br />As to the other issue with the keyword you are correct, I just went back a page and changed it and all was good. <br /> <br />Edit: again. Please don't wide post 4 feet of code inside code tags - it makes the whole thread stretch out and then it makes it difficult to read what's here.


Edited by JoshPet (06/19/03 08:56 PM)

Top
#233062 - 06/19/03 08:58 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
OK - <br />Well perhaps - you keep wide posting even after I keep editing to correct them. <img src="/forum/images/graemlins/wink.gif" alt="" /><br /><br />OK - what version are you running?<br />Did you have this mod installed before?<br /><br />[]<br />Duplicate column name 'B_Last_Number' [/]<br /><br />The database column is already there.
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233063 - 06/19/03 09:35 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
version 6.2.3 (I know it said 6.2 but thought it would work with 6.2.3) <br />Okay I just made sure all the columns were dropped which they were, I uploaded the modified files again and ran createlastpostfields-6.2.php and it created fine with no errors. Now on the site I am getting no errors yet it's as if the mod isn't there, the last post is the same as it was. <br /> <br />xxx is a zip file if you would like to see the modified files. If I have to I will just live without the mod, I know it's now available in 6.3 but I do not want to re-mod my board with everything again. It makes no sense to me why they would remove such a feature to begin with. Thanks Josh.


Edited by JoshPet (06/19/03 10:03 PM)

Top
#233064 - 06/19/03 09:42 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Yes, it'll work under 6.2.3 - if you had it installed before, you didn't need to add the database fields - as they were already there.<br /><br />If you dropped the tables - then you dropped all the data with it. So if you aren't getting any errors - you are probably on the right track. But there will be no info until replies are posted from this point on.<br /><br />The scripts looked good. I removed the link to them after I looked - Infopop can shut us down for posting copyrighted scripts on our board. <img src="/forum/images/graemlins/wink.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233065 - 06/19/03 10:12 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
Thanks, It does appear to be working but only half way. All I get is "By" without a user name, you can stop in and take a look if you want here is a thread that just got a post http://www.vhfans.com/boards/postlist.php?Cat=&Board=stage

Top
#233066 - 06/20/03 02:38 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
It turns out that I am having trouble uploading at home. Josh, you said my files looked right and you were correct sir, they were right. Today when I uploaded those exact same files from work the they were all larger than the one's I had uploaded last night. Not sure why that would happen really. Thanks again for all the help here Josh.

Top
#233067 - 06/20/03 02:41 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: BlarC]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
Glad you got it working. <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233068 - 08/10/03 05:38 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
The Duke of URL Offline
Member

Registered: 10/02/00
Posts: 205
how do we remove this from the database before upgrading to 6.3?
_________________________
Duke

"Life is tough, it's tougher if you're stupid."

Top
#233069 - 08/10/03 06:29 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: ]
JoshPet Offline
I type Like navaho

Registered: 11/29/01
Posts: 11330
Loc: Charlotte, NC
It won't hurt to upgrade to 6.3 with it.... but if you want to get rid of the unused fields..... backup your database first <br /><br />Then <br /><br />ALTER TABLE w3t_Posts <br />DROP B_Last_Number,<br />DROP B_Last_Name,<br />DROP B_Last_Approved<br /><br /><br /><br />That should do it. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />
_________________________
Joshua Pettit
www.JoshuaPettit.com
My abilities are for hire.

Top
#233070 - 08/10/03 07:33 PM Re: [6.2] Postlist Last Post By for 6.2 [Re: Daine]
The Duke of URL Offline
Member

Registered: 10/02/00
Posts: 205
merci <img src="/forum/images/graemlins/smile.gif" alt="" />
_________________________
Duke

"Life is tough, it's tougher if you're stupid."

Top
Page 1 of 3 1 2 3 >



Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks